{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"Exer. 8 - Simulação  Automático"]
[null,null,null,null,"Min","Max"]
[null,null,"Tempo Vida",null,2,5]
[null,null,"Nº Acidentes/mês ",null,{"$f":"1/12","v":8.3333333333333329E-2},null,"Período Revisão (meses)",null,null,null,3]
[null,null,"Custo Peça",null,100,null,"Intervalo mínimo Subst. Peça",null,null,null,1.5]
[null,null,"Custo/Inspecção/Ver",null,1000]
[null,null,"Custo/paragem",null,2000]
[]
[null,"Tempo","Tipo","Subst. ","Prox. Inter. acidentes",null,"Prox","Bom Func. Peça",null,"Prox.","Próx.","Próximo","Tipo","Nº","Nº ","Nº ","Nº "]
[null,null,"Acontec.","Peça?","NPA","Meses","Acidente","NPA","Meses","Avaria","Revisão","Acontec.","Acontec.","Peças","Revis.","Ava.","Ac."]
[null,0,"Acidente","Sim",0.58799999999999997,{"$f":"IF(E11=\"\",\"\",-1/$E$4*LN(E11))","v":6.3723399730021226},{"$f":"+F11","v":6.3723399730021226},7.1999999999999995E-2,{"$f":"IF(H11=\"\",0,$E$3+H11*($F$3-$E$3))","v":2.2160000000000002},{"$f":"+I11","v":2.2160000000000002},{"$f":"+$K$4","v":3},{"$f":"MIN(G11,J11,K11)","v":2.2160000000000002},{"$f":"IF(G11<K11,\"Acidente\",IF(I11<K11,\"Avaria\",\"Revisão\"))","v":"Avaria"},{"$f":"IF(D11=\"Sim\",1,0)","v":1},{"$f":"IF(C11=\"Revisão\",1,0)","v":0},{"$f":"IF(C11=\"Avaria\",1,0)","v":0},{"$f":"IF(C11=\"Acidente\",1,0)","v":1}]
[null,{"$f":"+L11","v":2.2160000000000002},"Avaria",{"$f":"IF(C12=\"Acidente\",\"Sim\",IF(C12=\"Avaria\",\"Sim\",IF(C12=\"Revisão\",IF((B12-B11)>$K$5,\"Sim\",\"Não\"))))","v":"Sim"},{"$f":"IF(C12=\"Acidente\", RAND(),\"\")","v":""},"",{"$f":"IF(F12=\"\",G11,+G11+F12)","v":6.3723399730021226},2.9000000000000001E-2,{"$f":"IF(H12=\"\",0,$E$3+H12*($F$3-$E$3))","v":2.0870000000000002},{"$f":"IF(D12=\"Sim\",B12+I12,IF(J11>K11,J11,B12+I12))","v":4.3030000000000008},{"$f":"IF(B12<K11,K11,K11+$K$4)","v":3},3,{"$f":"IF(G12<=L12,\"Acidente\",IF(J12<K12,\"Avaria\",\"Revisão\"))","v":"Revisão"},{"$f":"IF(D12=\"Sim\",1,0)","v":1},{"$f":"IF(C12=\"Revisão\",1,0)","v":0},{"$f":"IF(C12=\"Avaria\",1,0)","v":1},{"$f":"IF(C12=\"Acidente\",1,0)","v":0}]
[null,3,"Revisão",{"$f":"IF(C13=\"Acidente\",\"Sim\",IF(C13=\"Avaria\",\"Sim\",IF(C13=\"Revisão\",IF((B13-B12)>$K$5,\"Sim\",\"Não\"))))","v":"Não"},"","",6.3723399730021226,{"$f":"IF(D13=\"Sim\",RAND(),IF(J12>L12,\"\",RAND()))","v":""},{"$f":"IF(H13=\"\",0,$E$3+H13*($F$3-$E$3))","v":0},{"$f":"IF(D13=\"Sim\",B13+I13,IF(J12>K12,J12,B13+I13))","v":4.3030000000000008},6,4.3030000000000008,"Avaria",0,1,0,0]
[null,4.3030000000000008,"Avaria","Sim","","",6.3723399730021226,0.63400000000000001,3.9020000000000001,8.2050000000000018,6,6,"Revisão",1,0,1,0]
[null,6,"Revisão","Sim","","",6.3723399730021226,0.123,2.3689999999999998,8.3689999999999998,9,6.3723399730021226,"Acidente",1,1,0,0]
[null,6.3723399730021226,"Acidente","Sim",0.45700000000000002,9.3968626570551876,15.769202630057311,0.69899999999999995,4.0969999999999995,10.469339973002121,9,9,"Revisão",1,0,0,1]
[null,9,"Revisão","Sim","","",15.769202630057311,0.76100000000000001,4.2829999999999995,13.282999999999999,12,12,"Revisão",1,1,0,0]
[null,12,"Revisão","Sim","","",15.769202630057311,0.71699999999999997,4.1509999999999998,16.151,15,15,{"$f":"IF(G18<(L18+0.09),\"Acidente\",IF(J18<K18,\"Avaria\",\"Revisão\"))","v":"Revisão"},1,1,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N3:N18)","v":7},{"$f":"SUM(O3:O18)","v":4},{"$f":"SUM(P3:P18)","v":2},{"$f":"SUM(Q3:Q18)","v":2}]
[null,null,null,null,"Total","Mês"]
[null,"Custo das peças",null,null,{"$f":"N19*E5","v":700},{"$f":"+E21/$B$18","v":58.333333333333336}]
[null,"Custo das revisões",null,null,{"$f":"+O19*E6","v":4000},{"$f":"+E22/$B$18","v":333.33333333333331}]
[null,"Custos De paragens",null,null,{"$f":"+E7*(P19+Q19)","v":8000},{"$f":"+E23/$B$18","v":666.66666666666663}]
[null,"Custo Total",null,null,{"$f":"+E21+E22+E23","v":12700},{"$f":"+E24/$B$18","v":1058.3333333333333}]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}